Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	2775
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	325.3 KiB
Average record size in memory	120.0 B

Variable types

Numeric	15

Warnings

`gross_revenue` is highly correlated with `qtde_items`	High correlation
`qtde_items` is highly correlated with `gross_revenue`	High correlation
`avg_ticket` is highly skewed (γ1 = 27.68809767)	Skewed
`frequency_purchase` is highly skewed (γ1 = 47.42232667)	Skewed
`df_index` has unique values	Unique
`recency_days` has 33 (1.2%) zeros	Zeros
`returns` has 1483 (53.4%) zeros	Zeros

Reproduction

Analysis started	2021-05-25 14:12:44.340729
Analysis finished	2021-05-25 14:13:14.086198
Duration	29.75 seconds
Software version	pandas-profiling v2.13.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	2775
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2248.812252

Minimum	0
Maximum	5694
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	181.4
Q1	895.5
median	2055
Q3	3408.5
95-th percentile	4956.3
Maximum	5694
Range	5694
Interquartile range (IQR)	2513

Descriptive statistics

Standard deviation	1526.103739
Coefficient of variation (CV)	0.6786265673
Kurtosis	-0.9555046207
Mean	2248.812252
Median Absolute Deviation (MAD)	1238
Skewness	0.3811143644
Sum	6240454
Variance	2328992.623
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
599	1	< 0.1%
2638	1	< 0.1%
591	1	< 0.1%
593	1	< 0.1%
2642	1	< 0.1%
595	1	< 0.1%
2644	1	< 0.1%
597	1	< 0.1%
2646	1	< 0.1%
Other values (2765)	2765	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
5694	1	< 0.1%
5684	1	< 0.1%
5678	1	< 0.1%
5653	1	< 0.1%
5647	1	< 0.1%

customer_id
Real number (ℝ_≥0)

Distinct	2767
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15277.96396

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	12347
5-th percentile	12614.4
Q1	13804.5
median	15240
Q3	16779.5
95-th percentile	17950.3
Maximum	18287
Range	5940
Interquartile range (IQR)	2975

Descriptive statistics

Standard deviation	1721.261834
Coefficient of variation (CV)	0.112663038
Kurtosis	-1.211386655
Mean	15277.96396
Median Absolute Deviation (MAD)	1489
Skewness	0.01595493513
Sum	42396350
Variance	2962742.301
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12370	2	0.1%
12431	2	0.1%
12457	2	0.1%
12394	2	0.1%
12422	2	0.1%
12417	2	0.1%
12455	2	0.1%
12429	2	0.1%
16384	1	< 0.1%
15002	1	< 0.1%
Other values (2757)	2757	99.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	2762
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2845.153449

Minimum	36.56
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	36.56
5-th percentile	264.566
Q1	629.045
median	1169.94
Q3	2427.565
95-th percentile	7395.585
Maximum	279138.02
Range	279101.46
Interquartile range (IQR)	1798.52

Descriptive statistics

Standard deviation	10462.81725
Coefficient of variation (CV)	3.677417558
Kurtosis	373.090023
Mean	2845.153449
Median Absolute Deviation (MAD)	691.16
Skewness	17.1046029
Sum	7895300.82
Variance	109470544.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3226.1	2	0.1%
1080.48	2	0.1%
2339.86	2	0.1%
3425.69	2	0.1%
331	2	0.1%
734.94	2	0.1%
6382.45	2	0.1%
745.06	2	0.1%
379.65	2	0.1%
2043.23	2	0.1%
Other values (2752)	2755	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%

recency_days
Real number (ℝ_≥0)

ZEROS

Distinct	252
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.57369369

Minimum	0
Maximum	372
Zeros	33
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	10
median	29
Q3	73
95-th percentile	211
Maximum	372
Range	372
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	68.34408861
Coefficient of variation (CV)	1.208054206
Kurtosis	3.456145254
Mean	56.57369369
Median Absolute Deviation (MAD)	23
Skewness	1.902657391
Sum	156992
Variance	4670.914448
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.6%
4	86	3.1%
3	86	3.1%
2	85	3.1%
8	76	2.7%
10	67	2.4%
9	67	2.4%
7	65	2.3%
17	62	2.2%
22	55	2.0%
Other values (242)	2027	73.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	33	1.2%
1	99	3.6%
2	85	3.1%
3	86	3.1%
4	86	3.1%

Value	Count	Frequency (%)
372	1	< 0.1%
366	1	< 0.1%
360	1	< 0.1%
358	3	0.1%
354	1	< 0.1%

qtde_invoices
Real number (ℝ_≥0)

Distinct	55
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.05981982

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.070779717
Coefficient of variation (CV)	1.496872842
Kurtosis	183.9137519
Mean	6.05981982
Median Absolute Deviation (MAD)	2
Skewness	10.62190999
Sum	16816
Variance	82.27904467
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	778	28.0%
3	498	17.9%
4	394	14.2%
5	238	8.6%
6	174	6.3%
7	138	5.0%
8	97	3.5%
9	70	2.5%
10	55	2.0%
11	54	1.9%
Other values (45)	279	10.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	778	28.0%
3	498	17.9%
4	394	14.2%
5	238	8.6%
6	174	6.3%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%

qtde_items
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1634
Distinct (%)	58.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1672.284685

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	119.7
Q1	330.5
median	707
Q3	1485.5
95-th percentile	4610.5
Maximum	196844
Range	196842
Interquartile range (IQR)	1155

Descriptive statistics

Standard deviation	5888.405154
Coefficient of variation (CV)	3.521173882
Kurtosis	485.8647154
Mean	1672.284685
Median Absolute Deviation (MAD)	455
Skewness	18.18482489
Sum	4640590
Variance	34673315.26
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
246	8	0.3%
150	8	0.3%
493	7	0.3%
300	7	0.3%
272	7	0.3%
219	7	0.3%
394	7	0.3%
516	7	0.3%
1200	7	0.3%
Other values (1624)	2699	97.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%

qtde_products
Real number (ℝ_≥0)

Distinct	466
Distinct (%)	16.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	129.7556757

Minimum	2
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	10
Q1	34
median	72
Q3	143
95-th percentile	399.9
Maximum	7838
Range	7836
Interquartile range (IQR)	109

Descriptive statistics

Standard deviation	277.7016109
Coefficient of variation (CV)	2.140188546
Kurtosis	337.1075724
Mean	129.7556757
Median Absolute Deviation (MAD)	45
Skewness	15.35671564
Sum	360072
Variance	77118.1847
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	38	1.4%
35	34	1.2%
26	30	1.1%
29	30	1.1%
27	30	1.1%
25	28	1.0%
31	27	1.0%
15	27	1.0%
19	27	1.0%
33	26	0.9%
Other values (456)	2478	89.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	11	0.4%
3	12	0.4%
4	16	0.6%
5	16	0.6%
6	24	0.9%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%

qtde_unique_products
Real number (ℝ_≥0)

Distinct	340
Distinct (%)	12.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	83.35495495

Minimum	1
Maximum	1786
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	29
median	57
Q3	105
95-th percentile	239.3
Maximum	1786
Range	1785
Interquartile range (IQR)	76

Descriptive statistics

Standard deviation	98.70296808
Coefficient of variation (CV)	1.184128384
Kurtosis	80.66815713
Mean	83.35495495
Median Absolute Deviation (MAD)	33
Skewness	6.352949609
Sum	231310
Variance	9742.275908
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37	38	1.4%
24	37	1.3%
26	36	1.3%
25	35	1.3%
33	34	1.2%
28	34	1.2%
30	32	1.2%
18	32	1.2%
15	30	1.1%
52	29	1.0%
Other values (330)	2438	87.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	19	0.7%
2	13	0.5%
3	17	0.6%
4	18	0.6%
5	23	0.8%

Value	Count	Frequency (%)
1786	1	< 0.1%
1766	1	< 0.1%
1322	1	< 0.1%
1118	1	< 0.1%
884	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

SKEWED

Distinct	2767
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.10453979

Minimum	2.150588235
Maximum	4453.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2.150588235
5-th percentile	4.852950497
Q1	12.43090098
median	17.94081081
Q3	25.10118182
95-th percentile	87.67205263
Maximum	4453.43
Range	4451.279412
Interquartile range (IQR)	12.67028084

Descriptive statistics

Standard deviation	107.5928583
Coefficient of variation (CV)	3.351328474
Kurtosis	1055.381089
Mean	32.10453979
Median Absolute Deviation (MAD)	6.342522523
Skewness	27.68809767
Sum	89090.09792
Variance	11576.22316
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.63668675	2	0.1%
27.39248927	2	0.1%
17.62896175	2	0.1%
34.63101695	2	0.1%
17.98842105	2	0.1%
36.04680851	2	0.1%
43.2192	2	0.1%
27.52776471	2	0.1%
3.632881356	1	< 0.1%
8.292156863	1	< 0.1%
Other values (2757)	2757	99.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%

Value	Count	Frequency (%)
4453.43	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

Distinct	305
Distinct (%)	11.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.42918919

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	13
Q1	34
median	59
Q3	99
95-th percentile	224
Maximum	366
Range	365
Interquartile range (IQR)	65

Descriptive statistics

Standard deviation	66.52989591
Coefficient of variation (CV)	0.8482797871
Kurtosis	3.700911137
Mean	78.42918919
Median Absolute Deviation (MAD)	30
Skewness	1.833646582
Sum	217641
Variance	4426.22705
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35	40	1.4%
70	39	1.4%
55	37	1.3%
31	36	1.3%
45	36	1.3%
21	36	1.3%
25	35	1.3%
26	34	1.2%
46	34	1.2%
38	33	1.2%
Other values (295)	2415	87.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	9	0.3%
2	5	0.2%
3	8	0.3%
4	8	0.3%
5	5	0.2%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	0.1%

returns
Real number (ℝ_≥0)

ZEROS

Distinct	23
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.124684685

Minimum	0
Maximum	45
Zeros	1483
Zeros (%)	53.4%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	4
Maximum	45
Range	45
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.375741003
Coefficient of variation (CV)	2.112361834
Kurtosis	106.8386356
Mean	1.124684685
Median Absolute Deviation (MAD)	0
Skewness	7.759467296
Sum	3121
Variance	5.644145313
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
0	1483	53.4%
1	656	23.6%
2	270	9.7%
3	139	5.0%
4	92	3.3%
5	38	1.4%
6	32	1.2%
7	21	0.8%
9	8	0.3%
12	5	0.2%
Other values (13)	31	1.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1483	53.4%
1	656	23.6%
2	270	9.7%
3	139	5.0%
4	92	3.3%

Value	Count	Frequency (%)
45	1	< 0.1%
44	1	< 0.1%
35	1	< 0.1%
27	1	< 0.1%
21	1	< 0.1%

latitude
Real number (ℝ)

Distinct	28
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.48388445

Minimum	-25.274398
Maximum	64.963051
Zeros	0
Zeros (%)	0.0%
Negative	8
Negative (%)	0.3%
Memory size	21.8 KiB

Quantile statistics

Minimum	-25.274398
5-th percentile	50.503887
Q1	55.378051
median	55.378051
Q3	55.378051
95-th percentile	55.378051
Maximum	64.963051
Range	90.237449
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	5.18198778
Coefficient of variation (CV)	0.09511046858
Kurtosis	164.9603122
Mean	54.48388445
Median Absolute Deviation (MAD)	0
Skewness	-11.49946557
Sum	151192.7794
Variance	26.85299735
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
55.378051	2515	90.6%
51.165691	67	2.4%
46.227638	58	2.1%
40.463667	20	0.7%
50.503887	19	0.7%
46.818188	12	0.4%
39.399872	11	0.4%
-25.274398	8	0.3%
56.26392	7	0.3%
61.92411	7	0.3%
Other values (18)	51	1.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-25.274398	8	0.3%
1.352083	1	< 0.1%
31.046051	1	< 0.1%
35.126413	4	0.1%
35.937496	1	< 0.1%

Value	Count	Frequency (%)
64.963051	1	< 0.1%
61.92411	7	0.3%
60.472024	6	0.2%
60.128161	4	0.1%
56.26392	7	0.3%

longitude
Real number (ℝ)

Distinct	28
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-1.911966504

Minimum	-106.346771
Maximum	138.252924
Zeros	0
Zeros (%)	0.0%
Negative	2552
Negative (%)	92.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	-106.346771
5-th percentile	-3.435973
Q1	-3.435973
median	-3.435973
Q3	-3.435973
95-th percentile	8.227512
Maximum	138.252924
Range	244.599695
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	10.70437596
Coefficient of variation (CV)	-5.598621071
Kurtosis	134.0336741
Mean	-1.911966504
Median Absolute Deviation (MAD)	0
Skewness	9.896905264
Sum	-5305.707049
Variance	114.5836646
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
-3.435973	2515	90.6%
10.451526	67	2.4%
2.213749	58	2.1%
-3.74922	20	0.7%
4.469936	19	0.7%
8.227512	12	0.4%
-8.224454	11	0.4%
133.775136	8	0.3%
9.501785	7	0.3%
25.748151	7	0.3%
Other values (18)	51	1.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-106.346771	1	< 0.1%
-95.712891	1	< 0.1%
-19.020835	1	< 0.1%
-8.24389	3	0.1%
-8.224454	11	0.4%

Value	Count	Frequency (%)
138.252924	5	0.2%
133.775136	8	0.3%
103.819836	1	< 0.1%
34.851612	1	< 0.1%
33.429859	4	0.1%

frequency_purchase
Real number (ℝ_≥0)

SKEWED

Distinct	1228
Distinct (%)	44.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.06181163036

Minimum	0.005464480874
Maximum	34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0.005464480874
5-th percentile	0.008771929825
Q1	0.01587301587
median	0.02452316076
Q3	0.04215713428
95-th percentile	0.1179152512
Maximum	34
Range	33.99453552
Interquartile range (IQR)	0.02628411841

Descriptive statistics

Standard deviation	0.6693187857
Coefficient of variation (CV)	10.82836324
Kurtosis	2387.960895
Mean	0.06181163036
Median Absolute Deviation (MAD)	0.01078689703
Skewness	47.42232667
Sum	171.5272742
Variance	0.4479876369
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.07142857143	16	0.6%
0.04761904762	15	0.5%
0.01587301587	14	0.5%
0.0303030303	14	0.5%
0.02857142857	14	0.5%
0.02380952381	13	0.5%
0.06451612903	13	0.5%
0.1428571429	13	0.5%
0.025	12	0.4%
0.1176470588	12	0.4%
Other values (1218)	2639	95.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005509641873	1	< 0.1%
0.005602240896	2	0.1%

Value	Count	Frequency (%)
34	1	< 0.1%
6	1	< 0.1%
4	1	< 0.1%
2	6	0.2%
1.5	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

Distinct	974
Distinct (%)	35.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.48464482

Minimum	1
Maximum	297.8823529
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	3.5
Q1	10.04545455
median	17
Q3	27.33333333
95-th percentile	54.215
Maximum	297.8823529
Range	296.8823529
Interquartile range (IQR)	17.28787879

Descriptive statistics

Standard deviation	17.84655749
Coefficient of variation (CV)	0.8306656982
Kurtosis	27.52701801
Mean	21.48464482
Median Absolute Deviation (MAD)	8
Skewness	3.258241693
Sum	59619.88938
Variance	318.4996143
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	45	1.6%
17	30	1.1%
11	30	1.1%
14	28	1.0%
1	26	0.9%
7.5	25	0.9%
15	25	0.9%
9	25	0.9%
23	24	0.9%
9.5	24	0.9%
Other values (964)	2493	89.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	26	0.9%
1.2	1	< 0.1%
1.25	1	< 0.1%
1.333333333	2	0.1%
1.5	8	0.3%

Value	Count	Frequency (%)
297.8823529	1	< 0.1%
191	1	< 0.1%
135.3333333	1	< 0.1%
129.75	1	< 0.1%
125.75	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	qtde_unique_products	avg_ticket	avg_recency_days	returns	latitude	longitude	frequency_purchase	avg_basket_size
0	0	17850	5391.21	372.0	34.0	1733.0	297.0	21.0	18.152222	1.0	1.0	55.378051	-3.435973	34.000000	8.735294
1	1	13047	3232.59	56.0	9.0	1390.0	171.0	105.0	18.904035	52.0	7.0	55.378051	-3.435973	0.028391	19.000000
2	2	12583	6705.38	2.0	15.0	5028.0	232.0	114.0	28.902500	26.0	2.0	46.227638	2.213749	0.040431	15.466667
3	3	13748	948.25	95.0	5.0	439.0	28.0	24.0	33.866071	92.0	0.0	55.378051	-3.435973	0.017986	5.600000
4	4	15100	876.00	333.0	3.0	80.0	3.0	1.0	292.000000	20.0	3.0	55.378051	-3.435973	0.075000	1.000000
5	5	15291	4623.30	25.0	14.0	2102.0	102.0	61.0	45.326471	26.0	5.0	55.378051	-3.435973	0.040230	7.285714
6	6	14688	5630.87	7.0	21.0	3621.0	327.0	148.0	17.219786	19.0	6.0	55.378051	-3.435973	0.057377	15.285714
7	7	17809	5411.91	16.0	12.0	2057.0	61.0	46.0	88.719836	39.0	2.0	55.378051	-3.435973	0.033613	5.083333
8	8	15311	60767.90	0.0	91.0	38194.0	2379.0	567.0	25.543464	4.0	27.0	55.378051	-3.435973	0.243968	25.901099
9	9	16098	2005.63	87.0	7.0	613.0	67.0	34.0	29.934776	47.0	0.0	55.378051	-3.435973	0.024476	9.428571

Last rows

	df_index	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	qtde_unique_products	avg_ticket	avg_recency_days	returns	latitude	longitude	frequency_purchase	avg_basket_size
2765	5609	17290	525.24	3.0	2.0	404.0	102.0	92.0	5.149412	13.0	0.0	55.378051	-3.435973	0.153846	47.000000
2766	5618	14785	77.40	10.0	2.0	84.0	3.0	2.0	25.800000	5.0	0.0	55.378051	-3.435973	0.400000	1.500000
2767	5619	17254	272.44	4.0	2.0	252.0	112.0	100.0	2.432500	11.0	0.0	55.378051	-3.435973	0.181818	55.500000
2768	5635	17232	421.52	2.0	2.0	203.0	36.0	30.0	11.708889	12.0	0.0	55.378051	-3.435973	0.166667	17.500000
2769	5636	17468	137.00	10.0	2.0	116.0	5.0	5.0	27.400000	4.0	0.0	55.378051	-3.435973	0.500000	2.500000
2770	5647	13596	697.04	5.0	2.0	406.0	166.0	133.0	4.199036	7.0	0.0	55.378051	-3.435973	0.285714	69.000000
2771	5653	14893	1237.85	9.0	2.0	799.0	73.0	72.0	16.956849	2.0	0.0	55.378051	-3.435973	1.000000	36.500000
2772	5678	14126	706.13	7.0	3.0	508.0	15.0	14.0	47.075333	3.0	1.0	55.378051	-3.435973	1.000000	5.000000
2773	5684	13521	1092.39	1.0	3.0	733.0	435.0	312.0	2.511241	4.0	0.0	55.378051	-3.435973	0.333333	135.333333
2774	5694	15060	301.84	8.0	4.0	262.0	120.0	80.0	2.515333	1.0	0.0	55.378051	-3.435973	4.000000	27.500000

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows